package net.jxtz.jxtzos.entity.spider;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * @author lmh
 * @version 1.0
 * @date 2021-09-14 08:58
 */

@Data
@EqualsAndHashCode(exclude = {"id", "createTime"})
public class SpiderXinjianHousing implements Serializable {

    @JsonFormat(shape = JsonFormat.Shape.STRING)
    @ExcelIgnore
    private Long id;

    @ExcelProperty("预售/可售")
    private String saleStatus;

    @ExcelProperty("预售许可")
    private String preId;

    @ExcelProperty("开发商")
    private String devCompany;

    @ExcelProperty("项目名称")
    private String projectName;

    @ExcelProperty("项目坐落")
    private String projectAreaName;

    @ExcelProperty("批准日期")
    private String passTime;

    @ExcelProperty("规划用途")
    private String using;

    @ExcelProperty("售楼电话")
    private String salePhone;

    @ExcelProperty("土地来源")
    private String landSource;

    @ExcelProperty("土地面积")
    private String landArea;

    @ExcelProperty("占地面积")
    private String occupationArea;

    @ExcelProperty("小区建筑面积")
    private String communityBuildArea;

    @ExcelProperty("土地级别")
    private String landLevel;

    @ExcelProperty("容积率")
    private String plotRatio;

    @ExcelProperty("绿地率")
    private String greenRatio;

    @ExcelProperty("建筑密度")
    private String buildDensity;

    @ExcelProperty("工程投资")
    private String projectInvestment;

    @ExcelProperty("开工日期")
    private String startProjectTime;

    @ExcelProperty("竣工日期")
    private String endProjectTime;

    @ExcelProperty("施工单位")
    private String constructionUnit;

    @ExcelProperty("测绘单位")
    private String mappingUnit;

    @ExcelProperty("批准销售住宅套数")
    private Integer approveHouseNumber;

    @ExcelProperty("可售住宅套数")
    private Integer inSaleHouseNumber;

    @ExcelProperty("已售住宅套数")
    private Integer outSaleHouseNumber;

    @ExcelProperty("批准销售住宅面积")
    private String approveHouseArea;

    @ExcelProperty("可售住宅面积")
    private String inSaleHouseArea;

    @ExcelProperty("已售住宅面积")
    private String outSaleHouseArea;

    @ExcelProperty("批准销售商业间数")
    private String approveBusinessNumber;

    @ExcelProperty("可售商业间数")
    private String inSaleBusinessNumber;

    @ExcelProperty("已售商业间数")
    private String outSaleBusinessNumber;

    @ExcelProperty("批准销售商业面积")
    private String approveBusinessArea;

    @ExcelProperty("可售商业面积")
    private String inSaleBusinessArea;

    @ExcelProperty("已售商业面积")
    private String outSaleBusinessArea;

    @ExcelProperty("批准销售写字楼间数")
    private String approveOfficeNumber;

    @ExcelProperty("可售写字楼间数")
    private String inSaleOfficeNumber;

    @ExcelProperty("已售写字楼间数")
    private String outSaleOfficeNumber;

    @ExcelProperty("批准销售写字楼面积")
    private String approveOfficeArea;

    @ExcelProperty("可售写字楼面积")
    private String inSaleOfficeArea;

    @ExcelProperty("已售写字楼面积")
    private String outSaleOfficeArea;

    @ExcelProperty("批准销售车库车位位数")
    private String approveParkingNumber;

    @ExcelProperty("可售车库车位位数")
    private String inSaleParkingNumber;

    @ExcelProperty("已售车库车位位数")
    private String outSaleParkingNumber;

    @ExcelProperty("批准销售车库车位面积")
    private String approveParkingArea;

    @ExcelProperty("可售车库车位面积")
    private String inSaleParkingArea;

    @ExcelProperty("已售车库车位面积")
    private String outSaleParkingArea;

    @ExcelProperty("批准销售其他套数")
    private String approveOtherNumber;

    @ExcelProperty("可售其他套数")
    private String inSaleOtherNumber;

    @ExcelProperty("已售其他套数")
    private String outSaleOtherNumber;

    @ExcelProperty("批准销售其他面积")
    private String approveOtherArea;

    @ExcelProperty("可售其他面积")
    private String inSaleOtherArea;

    @ExcelProperty("已售其他面积")
    private String outSaleOtherArea;

    @ExcelProperty("所在楼栋")
    private String building;

    @ExcelProperty("最大单元")
    private String unitNumber;

    @ExcelProperty("总楼层")
    private String allFloorNumber;

    @ExcelProperty("所在楼层")
    private String inFloorNumber;

    @ExcelProperty("门牌号")
    private String doorTag;

    @ExcelProperty("房屋结构")
    private String structure;

    @ExcelProperty("房屋状态")
    private String houseStatus;

    @ExcelProperty("房屋建筑面积")
    private String houseBuildArea;

    @ExcelProperty("套内建筑面积")
    private String dwellingSpace;

    @ExcelProperty("分摊面积")
    private String sharedArea;

    @ExcelProperty("房屋用途")
    private String houseUsing;

    @ExcelProperty("毛坯单价")
    private String roughcastUnitPrice;

    @ExcelProperty("装修单价")
    private String renovationUnitPrice;

    @ExcelProperty("房屋户型")
    private String houseType;

    @ExcelProperty("合同号")
    private String contractNumber;

    @ExcelIgnore
    private Long spiderLogId;


    @TableField(fill = FieldFill.INSERT)
    @ExcelIgnore
    private Integer createTime;

}
